class CreateEmployees < ActiveRecord::Migration
  def self.up
    create_table :VW_Employee, :id => false do |t|
      t.string    :EmployeeNumber
      t.string    :EmployeeType
      t.string    :BusinessUnit
      t.string    :Department
      t.string    :Office
      t.string    :Manager
      t.string    :JobTitle
      t.string    :Name
      t.string    :EMail
      t.string    :PhoneWork
      t.string    :PhoneCell
      t.string    :OfficeAddress
      t.string    :City
      t.string    :State
      t.string    :PostalCode
      t.string    :Country
      t.string    :SkypeName
      t.string    :WikiSpaceURL
      t.string    :BlogURL
      t.string    :CubeLocation
    end
  end

  def self.down
    drop_table :users
  end
end